Data Stores
In 1Validate, a data store describes where some external spatial data is being read from or written to.
This represents the data which will be analysed by Rules within 1Validate.
The data store can be:
-
Automatically supported formats such as Oracle Spatial databases (with or without workspaces enabled), Esri Shapefile, MapInfo Tab files.
-
Other data formats via an FME Desktop integration (requires an FME Desktop licence).
Formats available include file formats (e.g. Bentley DGN) and database formats (e.g. PostGIS). See Supported Data Store Types.
-
Other data formats available via project-specific bespoke data stores.
When running a session using a data store, the data is stored in the cache (see Session Cache).
Note: Names of classes and properties in 1Validate can contain any ISO 8859 characters. Unicode is not supported.
Note: All lengths, areas, and co-ordinates used in 1Validate are in dataset units (the co-ordinate system used in the external data source). 1Validate does not perform any automatic co-ordinate conversions.
Supported Data Store Types
1Validate supports the following types of datastores for input (reading) and output (writing), either as standard or using FME Desktop (which requires a licence):
Note: All formats listed below as using FME Desktop require FME Desktop Professional Edition, unless otherwise indicated.
Data Store Type | As standard | Using FME Desktop | ||
---|---|---|---|---|
Read | Write | Read | Write | |
Bentley Microstation Design (V8) |
||||
Comma Separated Value (CSV) |
||||
Autodesk AutoCAD DWG/DXF |
||||
Esri Enterprise Geodatabase |
1 | 2 | ||
Esri File Geodatabase |
||||
Esri Shapefile |
||||
MapInfo Tab |
||||
Microsoft SQL Server Spatial |
3 | |||
Oracle |
||||
PostGIS |
Commit / Copy-To Support
Not all data store types support the Commit task as a method of writing data back to a data store (see Commit Task). However, all data store types support the Copy-To task (see Copy To Task).
Data Store Type | Task Supported | |
---|---|---|
Commit | Copy-To | |
Bentley Microstation Design (V8) |
||
Comma Separated Value (CSV) |
||
Autodesk AutoCAD DWG/DXF |
||
Esri Enterprise Geodatabase |
||
Esri File Geodatabase |
||
Esri Shapefile |
||
MapInfo Tab |
||
Microsoft SQL Server Spatial |
||
Oracle |
||
PostGIS |